﻿CREATE TABLE [dbo].[timeLog] (
    [timeLogId]      INT           IDENTITY (1, 1) NOT NULL,
    [userId]         INT           NOT NULL,
    [activityTypeId] INT           NULL,
    [taskId]         INT           NULL,
    [description]    VARCHAR (400) NULL,
    [duration]       INT           NULL,
    [createDate]     DATETIME      NULL,
    [startTime]      DATETIME      NULL,
    [endTime]        DATETIME      NULL,
    [remainingHours] INT           NULL
);

